COS Reports onboarding guide

Introduction

This guide provides partners with the following:

  • Instructions on how to onboard for receiving COS reports

  • A description of the report generation process, including the generation schedule, SFTP file path conventions and report file naming conventions.

  • Additional points on COS reports

Steps for onboarding a client to receive COS reports

  • The partner emails Integration Support to set up an SFTP account.

  • Integration Support sends the partner an SFTP setup form, which the partner fills out and sends back to Integration Support.

  • CRB’s Integration Support emails the username/password information back to the partner.

  • The partner configures access to the SFTP folders, including access permissions for the folders.

    • The partner can set up sandbox and/or production folders within the SFTP master account.

  • Integration Support notifies the partner when the process is complete.

How reports are generated and named

Report generation process

Once the partner has been onboarded, the reports are scheduled to run daily at 3AM EST, and are uploaded immediately following that.

The report files are uploaded to the following paths:

  • \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\AccountActivity

  • \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\AccountBalance

  • \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\AchActivity

  • \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\Webhooks

  • \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\WireActivity

  • \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\Overdrawn Account Report

  • \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\RTP Daily Activity By Partner

Report file naming conventions

Report

Naming Convention

Account Activity Report

[PartnerName]_Daily_Account_Activity_[timestamp].csv

Account Balance Report

[PartnerName]_Daily_Account_Balance_[timestamp].csv

ACH Activity Report

[PartnerName]_Daily_Ach_Activity_[timestamp].csv

Note: Data team needs to consolidate the naming convention on this one since we have some variations.

Webhooks Report

[PartnerName]_Webhook_Events_[timestamp].csv

Wire Activity Report

[PartnerName]_Daily_Wire_[timestamp].csv

COS Overdrawn Account Report

Overdrawn Account Report_[date].xlsx

RTP Daily Activity By Partner Report

[PartnerName] RTP Activity Report_[timestamp].csv

Additional points

  • The partner receives a notification when a report is uploaded via SFTP.

  • The report files in the SFTP folders are not deleted automatically.

  • The reports will be PGP-encrypted.

  • In addition to .csv and .xlsx, reports can be delivered in formats such as MT940 and PDF. Partners can contact the Relationship Manager for assistance with delivering reports in alternative formats.